Table of contents
Invoice Forms

• Tables
  • CUSTOMERS
  • DISCOUNT
  • INVOICE
  • ITEMS
  • SHIP_TO
  • SHIPPERS
  • SOLD
  • TAX
• Queries
  • Items Sold
  • Items UnSold
  • qSubForm_Adv_Discount
  • qSubForm_Adv_Shipping
  • qSubForm_Adv_Tax
  • qSubForm_Adv_Total
  • qSubForm_SubTotal
  • qSubForm_Tax
  • qSubForm_Total
• Forms
  • 1. Invoice Unique Items
  • 2. Invoice Basic
  • 3. Invoice Intermediate
  • 4. Invoice Advanced
• Index

Index

Name	Type	Parent name	Parent type	Used by	Uses
1. Invoice Unique Items	Form		Database		INVOICE (Table)
2. Invoice Basic	Form		Database		INVOICE (Table)
3. Invoice Intermediate	Form		Database		INVOICE (Table)
4. Invoice Advanced	Form		Database		INVOICE (Table)
ADDRESS	Control	4. Invoice Advanced	Form
ADDRESS	Control	3. Invoice Intermediate	Form
BASE_FEE	Field	SHIPPERS	Table
CITY	Field	SHIP_TO	Table
CITY	Field	CUSTOMERS	Table
CUSTOMER	Field	Items Sold	Query
CUSTOMER_ID	Control	4. Invoice Advanced	Form
CUSTOMER_ID	Control	3. Invoice Intermediate	Form
CUSTOMER_ID	Control	2. Invoice Basic	Form
CUSTOMER_ID	Control	1. Invoice Unique Items	Form
CUSTOMER_ID	Field	INVOICE	Table
CUSTOMERS	Table		Database	Items Sold (Query) 1. Invoice Unique Items|listCUSTOMER_ID (Control) 2. Invoice Basic|listCUSTOMER_ID (Control) 3. Invoice Intermediate|SubForm_Address1 (Control) 3. Invoice Intermediate|listCUSTOMER_ID (Control) 4. Invoice Advanced|SubForm_Address1 (Control) 4. Invoice Advanced|listCUSTOMER_ID (Control)
datDATE	Control	4. Invoice Advanced	Form
datDATE	Control	3. Invoice Intermediate	Form
datDATE	Control	2. Invoice Basic	Form
datDATE	Control	1. Invoice Unique Items	Form
DATE	Control	4. Invoice Advanced	Form
DATE	Control	3. Invoice Intermediate	Form
DATE	Control	2. Invoice Basic	Form
DATE	Control	1. Invoice Unique Items	Form
DATE	Field	Items Sold	Query
DATE	Field	INVOICE	Table
DISC_CURRENCY	Field	SOLD	Table
DISC_PERCENT	Field	SOLD	Table
Discount	Control	4. Invoice Advanced	Form
DISCOUNT	Table		Database	qSubForm_Adv_Discount (Query) qSubForm_Adv_Tax (Query) 4. Invoice Advanced|listDiscount (Control)
Discount_Currency	Control	4. Invoice Advanced	Form
Discount_Currency	Control	3. Invoice Intermediate	Form
DISCOUNT_ID	Field	INVOICE	Table
Discount_Percentage	Control	4. Invoice Advanced	Form
Discount_Percentage	Control	3. Invoice Intermediate	Form
EXTENDED	Control	4. Invoice Advanced	Form
EXTENDED	Control	3. Invoice Intermediate	Form
EXTENDED	Control	2. Invoice Basic	Form
FIRSTNAME	Field	CUSTOMERS	Table
fmtID	Control	4. Invoice Advanced	Form
fmtID	Control	3. Invoice Intermediate	Form
fmtID	Control	2. Invoice Basic	Form
fmtID	Control	1. Invoice Unique Items	Form
ID	Control	4. Invoice Advanced	Form
ID	Control	3. Invoice Intermediate	Form
ID	Control	2. Invoice Basic	Form
ID	Control	1. Invoice Unique Items	Form
ID	Field	TAX	Table
ID	Field	SOLD	Table
ID	Field	SHIPPERS	Table
ID	Field	SHIP_TO	Table
ID	Field	INVOICE	Table
ID	Field	DISCOUNT	Table
ID	Field	CUSTOMERS	Table
INVOICE	Field	Items Sold	Query
INVOICE	Table		Database	SHIP_TO (Table) Items Sold (Query) qSubForm_Adv_Discount (Query) qSubForm_Adv_Shipping (Query) qSubForm_Adv_Tax (Query) 1. Invoice Unique Items (Form) 2. Invoice Basic (Form) 3. Invoice Intermediate (Form) 4. Invoice Advanced (Form)
INVOICE_DISCOUNT	Field	qSubForm_Adv_Discount	Query
Invoice_Forms_v2	Database		Database
INVOICE_ID	Field	qSubForm_Total	Query
INVOICE_ID	Field	qSubForm_Tax	Query
INVOICE_ID	Field	qSubForm_SubTotal	Query
INVOICE_ID	Field	qSubForm_Adv_Total	Query
INVOICE_ID	Field	qSubForm_Adv_Tax	Query
INVOICE_ID	Field	qSubForm_Adv_Shipping	Query
INVOICE_ID	Field	qSubForm_Adv_Discount	Query
INVOICE_ID	Field	SOLD	Table
INVOICE_ID	Field	SHIP_TO	Table
ITEM	Control	4. Invoice Advanced	Form
ITEM	Control	4. Invoice Advanced	Form		ITEMS (Table)
ITEM	Control	3. Invoice Intermediate	Form		ITEMS (Table)
ITEM	Control	3. Invoice Intermediate	Form
ITEM	Control	2. Invoice Basic	Form
ITEM	Control	2. Invoice Basic	Form		ITEMS (Table)
ITEM	Control	1. Invoice Unique Items	Form
ITEM	Control	1. Invoice Unique Items	Form		ITEMS (Table) SOLD (Table)
ITEM	Field	Items UnSold	Query
ITEM	Field	Items Sold	Query
ITEM	Field	ITEMS	Table
ITEM_ID	Field	Items UnSold	Query
ITEM_ID	Field	SOLD	Table
ITEM_ID	Field	ITEMS	Table
ITEM_NAME	Control	4. Invoice Advanced	Form
ITEM_NAME	Control	3. Invoice Intermediate	Form
ITEM_NAME	Control	2. Invoice Basic	Form
ITEM_NAME	Control	1. Invoice Unique Items	Form
ITEM_SERIAL	Control	1. Invoice Unique Items	Form
ITEM_SERIAL	Control	1. Invoice Unique Items	Form		ITEMS (Table) SOLD (Table)
ITEM_SKU	Control	4. Invoice Advanced	Form
ITEM_SKU	Control	4. Invoice Advanced	Form		ITEMS (Table)
ITEM_SKU	Control	3. Invoice Intermediate	Form		ITEMS (Table)
ITEM_SKU	Control	3. Invoice Intermediate	Form
ITEM_SKU	Control	2. Invoice Basic	Form
ITEM_SKU	Control	2. Invoice Basic	Form		ITEMS (Table)
ITEMS	Table		Database	Items Sold (Query) Items UnSold (Query) qSubForm_Adv_Shipping (Query) qSubForm_Adv_Tax (Query) qSubForm_SubTotal (Query) qSubForm_Tax (Query) 1. Invoice Unique Items|SubForm1|ITEM (Control) 1. Invoice Unique Items|SubForm1|ITEM_SERIAL (Control) 1. Invoice Unique Items|SubForm2 (Control) 1. Invoice Unique Items|SubForm3 (Control) 2. Invoice Basic|SubForm1|ITEM (Control) 2. Invoice Basic|SubForm1|ITEM_SKU (Control) 2. Invoice Basic|SubForm2 (Control) 2. Invoice Basic|SubForm3 (Control) 3. Invoice Intermediate|SubForm_Invoice2 (Control) 3. Invoice Intermediate|SubForm_Invoice1|ITEM (Control) 3. Invoice Intermediate|SubForm_Invoice1|ITEM_SKU (Control) 4. Invoice Advanced|SubForm_Customer|ITEM (Control) 4. Invoice Advanced|SubForm_Customer|ITEM_SKU (Control) 4. Invoice Advanced|SubForm_Invoice (Control)
Items Sold	Query		Database		INVOICE (Table) SOLD (Table) ITEMS (Table) CUSTOMERS (Table)
Items UnSold	Query		Database		ITEMS (Table) SOLD (Table)
LASTNAME	Field	CUSTOMERS	Table
lblSubTotal	Control	4. Invoice Advanced	Form
lblSubTotal	Control	3. Invoice Intermediate	Form
lblTax	Control	3. Invoice Intermediate	Form
lblTotal	Control	4. Invoice Advanced	Form
lblTotal	Control	3. Invoice Intermediate	Form
listCUSTOMER_ID	Control	4. Invoice Advanced	Form		CUSTOMERS (Table)
listCUSTOMER_ID	Control	3. Invoice Intermediate	Form		CUSTOMERS (Table)
listCUSTOMER_ID	Control	2. Invoice Basic	Form		CUSTOMERS (Table)
listCUSTOMER_ID	Control	1. Invoice Unique Items	Form		CUSTOMERS (Table)
listDiscount	Control	4. Invoice Advanced	Form		DISCOUNT (Table)
listShipper	Control	4. Invoice Advanced	Form		SHIPPERS (Table)
listTax	Control	4. Invoice Advanced	Form		TAX (Table)
NAME	Field	SHIPPERS	Table
NAME	Field	SHIP_TO	Table
NAVIGATION	Control	4. Invoice Advanced	Form
NAVIGATION	Control	3. Invoice Intermediate	Form
NAVIGATION	Control	2. Invoice Basic	Form
Navigation Bar 1	Control	4. Invoice Advanced	Form
Navigation Bar 1	Control	3. Invoice Intermediate	Form
Navigation Bar 1	Control	2. Invoice Basic	Form
Navigation Bar 1	Control	1. Invoice Unique Items	Form
Navigation Bar 3	Control	4. Invoice Advanced	Form
Navigation Bar 3	Control	3. Invoice Intermediate	Form
Navigation Bar 3	Control	2. Invoice Basic	Form
Navigation Bar 3	Control	1. Invoice Unique Items	Form
PACKAGING_FEE	Field	Items UnSold	Query
PACKAGING_FEE	Field	ITEMS	Table
PHONE	Field	SHIP_TO	Table
PHONE	Field	CUSTOMERS	Table
PRICE	Control	4. Invoice Advanced	Form
PRICE	Control	3. Invoice Intermediate	Form
PRICE	Control	2. Invoice Basic	Form
PRICE	Control	1. Invoice Unique Items	Form
PRICE	Field	Items UnSold	Query
PRICE	Field	Items Sold	Query
PRICE	Field	ITEMS	Table
Push Button 1	Control	4. Invoice Advanced	Form
Push Button 1	Control	4. Invoice Advanced	Form
Push Button 1	Control	4. Invoice Advanced	Form
Push Button 1	Control	3. Invoice Intermediate	Form
Push Button 1	Control	3. Invoice Intermediate	Form
Push Button 1	Control	3. Invoice Intermediate	Form
Push Button 1	Control	2. Invoice Basic	Form
Push Button 1	Control	1. Invoice Unique Items	Form
Push Button 2	Control	4. Invoice Advanced	Form
Push Button 2	Control	4. Invoice Advanced	Form
Push Button 2	Control	3. Invoice Intermediate	Form
Push Button 2	Control	3. Invoice Intermediate	Form
Push Button 2	Control	2. Invoice Basic	Form
Push Button 2	Control	1. Invoice Unique Items	Form
Push Button 3	Control	4. Invoice Advanced	Form
Push Button 3	Control	4. Invoice Advanced	Form
Push Button 3	Control	3. Invoice Intermediate	Form
Push Button 3	Control	3. Invoice Intermediate	Form
Push Button 3	Control	2. Invoice Basic	Form
Push Button 3	Control	1. Invoice Unique Items	Form
Push Button 4	Control	4. Invoice Advanced	Form
qSubForm_Adv_Discount	Query		Database	qSubForm_Adv_Total (Query) 4. Invoice Advanced|SubForm_SubTotal|SubForm_Discount (Control)	INVOICE (Table) DISCOUNT (Table) qSubForm_SubTotal (Query)
qSubForm_Adv_Shipping	Query		Database	qSubForm_Adv_Total (Query) 4. Invoice Advanced|SubForm_SubTotal|SubForm_Shipping (Control)	ITEMS (Table) SOLD (Table) INVOICE (Table) SHIPPERS (Table)
qSubForm_Adv_Tax	Query		Database	qSubForm_Adv_Total (Query) 4. Invoice Advanced|SubForm_SubTotal|SubForm_Tax (Control)	ITEMS (Table) SOLD (Table) INVOICE (Table) TAX (Table) DISCOUNT (Table)
qSubForm_Adv_Total	Query		Database	4. Invoice Advanced|SubForm_SubTotal|SubForm_Total (Control)	qSubForm_Adv_Tax (Query) qSubForm_SubTotal (Query) qSubForm_Adv_Shipping (Query) qSubForm_Adv_Discount (Query)
qSubForm_SubTotal	Query		Database	qSubForm_Adv_Discount (Query) qSubForm_Adv_Total (Query) qSubForm_Total (Query) 3. Invoice Intermediate|SubForm_SubTotal (Control) 4. Invoice Advanced|SubForm_SubTotal (Control)	ITEMS (Table) SOLD (Table)
qSubForm_Tax	Query		Database	qSubForm_Total (Query) 3. Invoice Intermediate|SubForm_SubTotal|SubForm_Tax (Control)	ITEMS (Table) SOLD (Table) TAX (Table)
qSubForm_Total	Query		Database	3. Invoice Intermediate|SubForm_SubTotal|SubForm_Total (Control)	qSubForm_Tax (Query) qSubForm_SubTotal (Query)
QTY	Control	4. Invoice Advanced	Form
QTY	Control	3. Invoice Intermediate	Form
QTY	Control	2. Invoice Basic	Form
QTY	Field	Items Sold	Query
QTY	Field	SOLD	Table
RATE	Field	TAX	Table
SERIAL	Control	1. Invoice Unique Items	Form
SERIAL	Field	Items Sold	Query
SHIP_TO	Table		Database	3. Invoice Intermediate|SubForm_Address2 (Control) 4. Invoice Advanced|SubForm_Address2 (Control)	INVOICE (Table)
SHIPPER_ID	Field	INVOICE	Table
SHIPPERS	Table		Database	qSubForm_Adv_Shipping (Query) 4. Invoice Advanced|listShipper (Control)
Shipping	Control	4. Invoice Advanced	Form
SHIPPING	Field	qSubForm_Adv_Shipping	Query
SHIPPING_ADDRESS	Control	4. Invoice Advanced	Form
SHIPPING_ADDRESS	Control	3. Invoice Intermediate	Form
SHIPPING_WT	Field	Items UnSold	Query
SHIPPING_WT	Field	ITEMS	Table
SKU	Control	4. Invoice Advanced	Form
SKU	Control	3. Invoice Intermediate	Form
SKU	Control	2. Invoice Basic	Form
SKU	Field	Items UnSold	Query
SKU	Field	ITEMS	Table
SOLD	Table		Database	Items Sold (Query) Items UnSold (Query) qSubForm_Adv_Shipping (Query) qSubForm_Adv_Tax (Query) qSubForm_SubTotal (Query) qSubForm_Tax (Query) 1. Invoice Unique Items|SubForm1 (Control) 1. Invoice Unique Items|SubForm1|ITEM (Control) 1. Invoice Unique Items|SubForm1|ITEM_SERIAL (Control) 1. Invoice Unique Items|SubForm2 (Control) 1. Invoice Unique Items|SubForm3 (Control) 2. Invoice Basic|SubForm1 (Control) 2. Invoice Basic|SubForm2 (Control) 2. Invoice Basic|SubForm3 (Control) 3. Invoice Intermediate|SubForm_Invoice2 (Control) 3. Invoice Intermediate|SubForm_Invoice1 (Control) 4. Invoice Advanced|SubForm_Customer (Control) 4. Invoice Advanced|SubForm_Invoice (Control)
STATE	Field	SHIP_TO	Table
STATE	Field	CUSTOMERS	Table
STREET	Field	SHIP_TO	Table
STREET	Field	CUSTOMERS	Table
SubForm_Address1	Control	4. Invoice Advanced	Form		CUSTOMERS (Table)
SubForm_Address1	Control	3. Invoice Intermediate	Form		CUSTOMERS (Table)
SubForm_Address2	Control	4. Invoice Advanced	Form		SHIP_TO (Table)
SubForm_Address2	Control	3. Invoice Intermediate	Form		SHIP_TO (Table)
SubForm_Customer	Control	4. Invoice Advanced	Form		SOLD (Table)
SubForm_Discount	Control	4. Invoice Advanced	Form		qSubForm_Adv_Discount (Query)
SubForm_Grid	Control	4. Invoice Advanced	Form
SubForm_Grid	Control	3. Invoice Intermediate	Form
SubForm_Grid	Control	2. Invoice Basic	Form
SubForm_Grid	Control	1. Invoice Unique Items	Form
SubForm_Invoice	Control	4. Invoice Advanced	Form		SOLD (Table) ITEMS (Table)
SubForm_Invoice1	Control	3. Invoice Intermediate	Form		SOLD (Table)
SubForm_Invoice2	Control	3. Invoice Intermediate	Form		SOLD (Table) ITEMS (Table)
SubForm_Shipping	Control	4. Invoice Advanced	Form		qSubForm_Adv_Shipping (Query)
SubForm_SubTotal	Control	4. Invoice Advanced	Form		qSubForm_SubTotal (Query)
SubForm_SubTotal	Control	3. Invoice Intermediate	Form		qSubForm_SubTotal (Query)
SubForm_Tax	Control	4. Invoice Advanced	Form		qSubForm_Adv_Tax (Query)
SubForm_Tax	Control	3. Invoice Intermediate	Form		qSubForm_Tax (Query)
SubForm_Tax_Rate	Control	3. Invoice Intermediate	Form		TAX (Table)
SubForm_Total	Control	4. Invoice Advanced	Form		qSubForm_Adv_Total (Query)
SubForm_Total	Control	3. Invoice Intermediate	Form		qSubForm_Total (Query)
SubForm1	Control	2. Invoice Basic	Form		SOLD (Table)
SubForm1	Control	1. Invoice Unique Items	Form		SOLD (Table)
SubForm2	Control	2. Invoice Basic	Form		SOLD (Table) ITEMS (Table)
SubForm2	Control	1. Invoice Unique Items	Form		SOLD (Table) ITEMS (Table)
SubForm3	Control	2. Invoice Basic	Form		ITEMS (Table) SOLD (Table)
SubForm3	Control	1. Invoice Unique Items	Form		ITEMS (Table) SOLD (Table)
SubTotal	Control	4. Invoice Advanced	Form
SubTotal	Control	3. Invoice Intermediate	Form
SUBTOTAL	Field	qSubForm_SubTotal	Query
Tax	Control	4. Invoice Advanced	Form
Tax	Control	3. Invoice Intermediate	Form
TAX	Table		Database	qSubForm_Adv_Tax (Query) qSubForm_Tax (Query) 3. Invoice Intermediate|SubForm_SubTotal|SubForm_Tax|SubForm_Tax_Rate (Control) 4. Invoice Advanced|listTax (Control)
TAX_ID	Field	INVOICE	Table
TAXABLE	Field	Items UnSold	Query
TAXABLE	Field	ITEMS	Table
TAXES	Field	qSubForm_Tax	Query
TAXES	Field	qSubForm_Adv_Tax	Query
Total	Control	4. Invoice Advanced	Form
Total	Control	3. Invoice Intermediate	Form
TOTAL	Control	2. Invoice Basic	Form
TOTAL	Control	2. Invoice Basic	Form
TOTAL	Control	1. Invoice Unique Items	Form
TOTAL	Control	1. Invoice Unique Items	Form
TOTAL	Field	qSubForm_Total	Query
TOTAL	Field	qSubForm_Adv_Total	Query
txtCITY	Control	4. Invoice Advanced	Form
txtCITY	Control	4. Invoice Advanced	Form
txtCITY	Control	3. Invoice Intermediate	Form
txtCITY	Control	3. Invoice Intermediate	Form
txtFULLNAME	Control	4. Invoice Advanced	Form
txtFULLNAME	Control	4. Invoice Advanced	Form
txtFULLNAME	Control	3. Invoice Intermediate	Form
txtFULLNAME	Control	3. Invoice Intermediate	Form
txtPHONE	Control	4. Invoice Advanced	Form
txtPHONE	Control	4. Invoice Advanced	Form
txtPHONE	Control	3. Invoice Intermediate	Form
txtPHONE	Control	3. Invoice Intermediate	Form
txtSTATE	Control	4. Invoice Advanced	Form
txtSTATE	Control	4. Invoice Advanced	Form
txtSTATE	Control	3. Invoice Intermediate	Form
txtSTATE	Control	3. Invoice Intermediate	Form
txtSTREET	Control	4. Invoice Advanced	Form
txtSTREET	Control	4. Invoice Advanced	Form
txtSTREET	Control	3. Invoice Intermediate	Form
txtSTREET	Control	3. Invoice Intermediate	Form
txtZIP	Control	4. Invoice Advanced	Form
txtZIP	Control	4. Invoice Advanced	Form
txtZIP	Control	3. Invoice Intermediate	Form
txtZIP	Control	3. Invoice Intermediate	Form
TYPE	Field	TAX	Table
UNITS	Field	DISCOUNT	Table
WEIGHT_RATE	Field	SHIPPERS	Table
ZIP	Field	SHIP_TO	Table
ZIP	Field	CUSTOMERS	Table